﻿/********************************************************************************************************************
* Author:	Christos Polydorou																						*
* Email:	std04237@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_activateEntity" that activates an		*
*			entity.																									*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_activateEntity]
	@entityid bigint
AS
	UPDATE Entities
	SET IsApproved = '1'
	WHERE Entities.id = @entityid
RETURN 0